class AddClientGroupColumns < ActiveRecord::Migration
  def self.up
    add_column :client_groups, :name, :string, :null => false
    add_column :client_groups, :serial_no, :integer
    add_column :client_groups, :folder_no, :integer
    add_column :client_groups, :bin, :string
    add_column :client_groups, :folder, :string
    add_column :client_groups, :client_since , :date, :default => Time.now
    add_column :client_groups, :contact_person, :string
    add_column :client_groups, :Telephone_r, :string
    add_column :client_groups, :Telephone_o, :string
    add_column :client_groups, :cell_no, :string
    add_column :client_groups, :email, :string
    add_column :client_groups, :residential_add_1, :string
    add_column :client_groups, :residential_add_2, :string
    add_column :client_groups, :residential_city, :string
    add_column :client_groups, :residential_state, :string
    add_column :client_groups, :residential_pin, :integer
    add_column :client_groups, :permanent_add_1, :string
    add_column :client_groups, :permanent_add_2, :string
    add_column :client_groups, :permanent_city, :string
    add_column :client_groups, :permanent_state, :string
    add_column :client_groups, :permanent_pin, :integer
    add_column :client_groups, :remarks, :text
  end

  def self.down
    remove_column :client_groups, :name000
    remove_column :client_groups, :serial_no, :integer
    remove_column :client_groups, :folder_no, :integer
    remove_column :client_groups, :bin
    remove_column :client_groups, :folder
    remove_column :client_groups, :client_since 
    remove_column :client_groups, :contact_person
    remove_column :client_groups, :Telephone_r
    remove_column :client_groups, :Telephone_o
    remove_column :client_groups, :cell_no
    remove_column :client_groups, :email
    remove_column :client_groups, :residential_add_1
    remove_column :client_groups, :residential_add_2
    remove_column :client_groups, :residential_cit
    remove_column :client_groups, :residential_state
    remove_column :client_groups, :residential_pin
    remove_column :client_groups, :permanent_add_1
    remove_column :client_groups, :permanent_add_2
    remove_column :client_groups, :permanent_city
    remove_column :client_groups, :permanent_state
    remove_column :client_groups, :permanent_pin
    remove_column :client_groups, :remarks
  end
end
